<!DOCTYPE html>
<html lang="fr">
	<head>
		<meta charset="utf-8" />
		<title>Boutique culturelle - <?php echo $title; ?></title>

		<link rel="stylesheet" href="style.css" />
		<link rel="icon" href="img/logo-16.png" />

		<!-- Bibliothèques. -->
		<script src="js/jquery/jquery-2.0.3.min.js"></script>
		<script src="js/jquery/jquery-ui.min.js"></script>
		<script src="js/jquery/jquery-ui-i18n.min.js"></script> <!-- Localisation de jQuery-ui -->
		<script src="js/jquery/jquery.tablesorter.min.js"></script>
		<script src="js/jquery/jquery.tablesorter.widgets.min.js"></script>
		<script src="js/jquery/jquery.tablesorter.pager.min.js"></script>


		<link rel="stylesheet" href="jquery-ui/base/jquery-ui.css" />
		<link rel="stylesheet" href="jquery.tablesorter/theme.default.css" />
		<link rel="stylesheet" href="jquery.tablesorter/jquery.tablesorter.pager.css" />

		<script>
			/* Au chargement de la page achevé... */
			$(function() {
				/* Initialisation de jQuery.tablesorter pour tous les tableaux de résultat. */
				$("table.results").each(function() {
					var $table = $(this);
					$table.tablesorter();
				})			
			});
		</script>
	</head>

	<body>

	<header>
		<h1>
			<a href="."><img src="img/logo-64.png" alt="Boutique culturelle" id="logo"/></a>
				<span class="title-group">
					<span class="title">Boutique culturelle - <?php echo $title; ?></span>
					<span class="subtitle">
						Bienvenue sur votre site de référence pour 
						l'achat de vos biens culturels en ligne.
					</span>
				</span>
		</h1>
		<nav id="menu-principal">
			<ul>
				<li>
					<a href="disques.php" tabindex="1">Disques</a>
					<ul>
						<li><a href="disques.php?cat=cd">CD</a></li>
						<li><a href="disques.php?cat=mp3">MP3</a></li>
					</ul>
				</li>
				<li>
					<a href="films.php" tabindex="11">Films</a>
					<ul>
						<li><a href="films.php?cat=dvd">DVD</a></li>
						<li><a href="films.php?cat=bluray">Blu-ray</a></li>
					</ul>
				</li>
				<li>
					<a href="livres.php" tabindex="21">Livres</a>
					<ul>
						<li><a href="livres.php?cat=relie">Reliés</a></li>
						<li><a href="livres.php?cat=ebook">E-books</a></li>
					</ul>
				</li>
				<li><a href="packs.php" tabindex="31">Pack Culture</a></li>
				<li><a href="admin.php" tabindex="41">Administration</a></li>
				<li class="search-item"><input type="search" name="recherche" placeholder="Tapez votre recherche" tabindex="51"/></li>
			</ul>
		</nav>

	</header>
<br/> <br/><br/> 

<div id="menu2">

	<ul class="menu">
		<li  classe ="item1"><a href="#">CD</a>

			<ul class= "shown">
				<li><a href="#">Pop-Rock </a></li>
				<li><a href="#">RnB </a></li>
				<li><a href="#">Classique </a></li>
			</ul>
		</li>
	</ul>
</div>
<br/> <br/><br/> 
<div>
<?php
{
	// On se connecte à MySQL
	$bdd = new PDO('mysql:host=localhost;dbname=test', 'root', '');
}
$results = $db->query('SELECT * FROM Disque');
			$results->setFetchMode(PDO::FETCH_OBJ);
?>
<h2><?php echo 'Disque';?></h2>
	<table id="tableau-catalogue" classe="results" border="1">
		<tr>
			<th>Pochette/Couverture</th>
			<th>Nom</th>
			<th>Genre</th>
			<th>Compositeur</th>
			<th>Date de sortie</th>
		</tr>
		<tr>
<?php
			while($row = $results->fetch()) {
?>
			<td class="image">
				<image scr="#" />
			</td>
			<td><?php echo $row->nom;?></td>
			<td><?php echo $row->genre;?></td>
			<td><?php echo $row->compositeur;?></td>
			<td><?php echo $row->anneeProduction;?></td>
		</tr>
<?php
			}
?>
	</table>
</div>


